﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
/*USE [enetamvc]
GO*/
/****** Object:  Table [dbo].[roles]    Script Date: 03/02/2012 14:10:12 ******/
SET IDENTITY_INSERT [dbo].[roles] ON
INSERT [dbo].[roles] ([role_id], [role_name]) VALUES (4, N'Administrator')
INSERT [dbo].[roles] ([role_id], [role_name]) VALUES (2, N'Moderator')
INSERT [dbo].[roles] ([role_id], [role_name]) VALUES (1, N'User')
SET IDENTITY_INSERT [dbo].[roles] OFF
/****** Object:  Table [dbo].[publish_state]    Script Date: 03/02/2012 14:10:12 ******/
/****** Object:  Table [dbo].[my_role]    Script Date: 03/02/2012 14:10:12 ******/
SET IDENTITY_INSERT [dbo].[my_role] ON
INSERT [dbo].[my_role] ([my_role_id], [my_role_name]) VALUES (2, N'Arendaja')
INSERT [dbo].[my_role] ([my_role_id], [my_role_name]) VALUES (1, N'Disainer')
INSERT [dbo].[my_role] ([my_role_id], [my_role_name]) VALUES (4, N'Huviline')
INSERT [dbo].[my_role] ([my_role_id], [my_role_name]) VALUES (3, N'Tudeng')
SET IDENTITY_INSERT [dbo].[my_role] OFF
/****** Object:  Table [dbo].[html_area]    Script Date: 03/02/2012 14:10:12 ******/
SET IDENTITY_INSERT [dbo].[html_area] ON
INSERT [dbo].[html_area] ([html_area_id], [name], [area_content], [visible]) VALUES (1, N'ProfileEdit', N'<b>Jee!</b>', 1)
SET IDENTITY_INSERT [dbo].[html_area] OFF
/****** Object:  Table [dbo].[users]    Script Date: 03/02/2012 14:10:12 ******/
SET IDENTITY_INSERT [dbo].[users] ON
INSERT [dbo].[users] ([user_id], [username], [email], [windowslivetoken], [first_name], [last_name], [description], [homepage], [address], [phone], [school], [field_of_study], [company], [job_title], [send_events_mails], [send_community_mails], [show_address], [show_job_title], [show_email], [show_field_of_study], [show_company], [show_school], [show_phone], [show_first_name], [show_last_name], [created], [modified], [locked]) VALUES (2, N'asd', N'asdasd', N'Sa%2F%2BuG1oCC7qU6EtVsnyqABIHnDEyrn8Ua5POSkn1vSxrLLGpAucTckdVjTWR8xkT6CWiI%2FCexWNblDJm3igTQ9ddKAaXoYHPn06SEnaJz6%2Bt0e7r39G7dY0HdnYXfoxFjL%2BBNJSrTDwrvCDYgvZvGhumZ59%2FqtCViA93ADLOqgLSZs3cB4ZpXOxzn6gi6BU1hiXORVrNojcTTiTPQMdJA%3D%3D', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A00300B6000D AS DateTime), CAST(0x0000A00300B6000D AS DateTime), 0)
INSERT [dbo].[users] ([user_id], [username], [email], [windowslivetoken], [first_name], [last_name], [description], [homepage], [address], [phone], [school], [field_of_study], [company], [job_title], [send_events_mails], [send_community_mails], [show_address], [show_job_title], [show_email], [show_field_of_study], [show_company], [show_school], [show_phone], [show_first_name], [show_last_name], [created], [modified], [locked]) VALUES (3, N'dasd', N'asdasd', N'wKaPMWGnUthPkaZOmqpSVXarwcD5oo81ThFoQCMs1z1O0uiVv7NgztyhuYCaNttsbK6IXNobc4lV6%2BACZDjlmyEkg3u8fG%2FNSQb2nhHoSBV3xRRO21RxS%2FC3sleEJCurObOv1YhvxIg1tyg9lV%2FNCFOYw9x5Ms0%2FkQXwFikaE2KZXX6v90H7rH2xBrNQ%2BZ16oEDcrsmdW7E3JEosmkkmfw%3D%3D', N'asd', N'aaaa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, CAST(0x0000A00300B5FF68 AS DateTime), CAST(0x0000A006014EACF4 AS DateTime), 0)
INSERT [dbo].[users] ([user_id], [username], [email], [windowslivetoken], [first_name], [last_name], [description], [homepage], [address], [phone], [school], [field_of_study], [company], [job_title], [send_events_mails], [send_community_mails], [show_address], [show_job_title], [show_email], [show_field_of_study], [show_company], [show_school], [show_phone], [show_first_name], [show_last_name], [created], [modified], [locked]) VALUES (4, N'qweqw', N'qweqwe', N'd2286471342dce67f6b600be74a81af8', N'Gunnar1', N'Peipman', N'Minu tagasihoidlik ja edasipüüdlik kirjeldus', N'http://www.attido.com/', N'Südalinn', N'53345656', N'TTÜ', N'Tehniline füüsika', N'Attido', N'Arhitekt', 1, 1, 0, 0, 1, 0, 0, 0, 0, 1, 0, CAST(0x0000A00300B5FF68 AS DateTime), CAST(0x0000A00601506C9C AS DateTime), 0)
SET IDENTITY_INSERT [dbo].[users] OFF
/****** Object:  Table [dbo].[user_role]    Script Date: 03/02/2012 14:10:12 ******/
INSERT [dbo].[user_role] ([user_id], [role_id]) VALUES (4, 1)
INSERT [dbo].[user_role] ([user_id], [role_id]) VALUES (4, 4)
/****** Object:  Table [dbo].[user_my_role]    Script Date: 03/02/2012 14:10:12 ******/
INSERT [dbo].[user_my_role] ([user_id], [my_role_id]) VALUES (4, 1)
INSERT [dbo].[user_my_role] ([user_id], [my_role_id]) VALUES (4, 4)
